/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 2310

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 52 45 53 |CHILD UP|DATE RES|
|00000010| 54 52 49 43 54 00 20 20 | 20 57 48 45 4e 20 28 28 |TRICT.  | WHEN ((|
|00000020| 28 73 65 6c 65 63 74 20 | 63 6f 75 6e 74 28 2a 29 |(select |count(*)|
|00000030| 20 66 72 6f 6d 20 25 50 | 61 72 65 6e 74 20 77 68 | from %P|arent wh|
|00000040| 65 72 65 20 25 4a 6f 69 | 6e 46 4b 50 4b 28 25 4e |ere %Joi|nFKPK(%N|
|00000050| 65 77 2c 25 50 61 72 65 | 6e 74 2c 22 20 3d 20 22 |ew,%Pare|nt," = "|
|00000060| 2c 22 20 61 6e 64 22 29 | 29 20 3d 20 30 29 0d 0a |," and")|) = 0)..|
|00000070| 20 20 20 20 20 25 49 66 | 20 28 25 4e 6f 74 6e 75 |     %If| (%Notnu|
|00000080| 6c 6c 46 4b 28 25 4e 65 | 77 2c 22 20 69 73 20 6e |llFK(%Ne|w," is n|
|00000090| 6f 74 20 6e 75 6c 6c 22 | 2c 2c 22 20 61 6e 64 22 |ot null"|,," and"|
|000000a0| 29 29 20 7b 20 41 4e 44 | 20 25 4e 6f 74 6e 75 6c |)) { AND| %Notnul|
|000000b0| 6c 46 4b 28 25 4e 65 77 | 2c 22 20 69 73 20 6e 6f |lFK(%New|," is no|
|000000c0| 74 20 6e 75 6c 6c 22 2c | 2c 22 20 61 6e 64 22 29 |t null",|," and")|
|000000d0| 7d 29 0d 0a 20 20 20 20 | 20 20 20 53 49 47 4e 41 |})..    |   SIGNA|
|000000e0| 4c 20 53 51 4c 53 54 41 | 54 45 20 27 34 32 39 38 |L SQLSTA|TE '4298|
|000000f0| 37 27 20 28 27 43 61 6e | 6e 6f 74 20 55 50 44 41 |7' ('Can|not UPDA|
|00000100| 54 45 20 22 25 43 68 69 | 6c 64 22 20 62 65 63 61 |TE "%Chi|ld" beca|
|00000110| 75 73 65 20 22 25 50 61 | 72 65 6e 74 22 20 64 6f |use "%Pa|rent" do|
|00000120| 65 73 20 6e 6f 74 20 65 | 78 69 73 74 2e 27 29 00 |es not e|xist.').|
|00000130| 1c 27                   |                         |.'      |        |
+--------+-------------------------+-------------------------+--------+--------+